import sqlite3
import xlrd

con = sqlite3.connect('infec.db')
cur = con.cursor()

workbook = xlrd.open_workbook('111.xlsx')
sheet = workbook.sheets()[1]
rows = sheet.nrows

for i in range(1,rows):
    sql = 'insert into lei values ({},"{}","{}","{}")'
    sql2 = sql.format(sheet.cell(i,0).value,sheet.cell(i,1).value,sheet.cell(i,2).value,sheet.cell(i,3).value)
    print(sql2)
    cur.execute(sql2)
con.commit()
